-
Re: Dates are formatting in 2 different ways on the same sheet
Quick note on the zero filling to make the day and month numbers two digits. RIGHT("0" + DAY([LATEST DATES / TIMES]6), 2) will completely replace the IF statement and both outputs you curre…1 · -
Re: Index Collect Simplification
Can you describe what the intent of the formula is? Based on how I am reading it, that is about as efficient as it gets to generate what I see as the output.1 · -
Re: how can i utilize when there are multiple selections from the dropdown
Make sure each {Cross Sheet Reference} that you are using has been created.1 · -
Re: How do I eliminate the column name.
When editing the widget, you can click on "Column6" and delete it the same as if you were going to change it to say something else. using this feature, you can also choose to link only the …2 · -
Re: Formula to determine row number
That's actually how I am using it. As a sort of TOC at the top of my Project Plans. I have two helper columns. One that pulls the row number for each parent task, and the other pulls the task name. I…2 ·